package ru.michaeltyan.familyconnector.dao;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import ru.michaeltyan.familyconnector.beans.Foodstuff;
import ru.michaeltyan.familyconnector.beans.FoodstuffList;

public interface FoodstuffManagerDao {
	List<Foodstuff> getAllFoodstuffs();

	List<FoodstuffList> getAllFoodstuffLists();

	List<Long> getAllIdsOfFoodstuffLists(Connection conn, Long foodstuffListId) throws SQLException;

	Foodstuff getFoodstuffById(Long id, Connection conn) throws SQLException;

	void closeConnection(Connection conn) throws SQLException;

	Connection openConnection() throws ClassNotFoundException, SQLException, FileNotFoundException, IOException;
}
